﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_DeleteBasicReferenceLocations')
	BEGIN
		DROP  Procedure  esf_sso.P_DeleteBasicReferenceLocations
	END
GO

CREATE PROCEDURE esf_sso.P_DeleteBasicReferenceLocations
	@pBasicReferenceID	INT
AS

	DELETE FROM esf_sso.BasicReference_Location
	WHERE BasicReferenceID = @pBasicReferenceID
	
GO   